﻿using System;

public partial class ModEmployee_ZipSeaForIn : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        string strSearchWord = txtSearchWord.Text.Trim();

        string strSearchSQL = "SELECT [DeptName], [EmpName], [EmpSex], [EmpCode],[DutyName] FROM [View_Emp] Where StateName<>'离职' and (EmpName like '%" + strSearchWord + "%' OR EmpCode like '%" + strSearchWord + "%')  ORDER BY JoinTime";
        EmployeeSDS.SelectCommand = strSearchSQL;
        gvEmployee.DataSourceID = EmployeeSDS.ID;
    }
}
